1. What is the difference between Informatica 8x and 9x?
2. How many types of fact and dimension tables are available?
3. What is fact-less fact table ?
4. How lookup is active in informatica 9.1 and what is the additional option added to lookup ?
5. How to update a table without update strategy or a table which does not have a primary key ?
6. What is the difference between lookup and joiner ?
7. What happens if we select all the port of an aggregator or if we dont select any port for group by?
8. What will be the output of a group of a router where no condition is given?
9. What are the limitations of a joiner ?
10. Is Union transformation in Informatica same as Union in Oracle? How to do the same as Oracle Union in Informatica?
11. What is GK_ID and GCID in Normalizer ?
12. Explain the use of Newlookup port in Dynamic lookup ?
13. What is the use of MD5 function in informatica?
14. Explain Incremental aggregation with a scenario ?
15. How to declare a mapplet variable in parameter file?
16. How to pass a mapping variable from one mapping to another with the help of workflow variable?
17. What is the command we need to use in parameter file to use both session parameter file and workflow parameter file simultaneously? [$PMMergeSessParamFile= TRUE]
18. What is the custom property we need to set in order to ignore new line character in between the data enclosed within quote? [ MatchQuotesPastEndOfLine=Yes]
19. Give an example of Informatica user defined function ?
20. How to handle Event Wait task for dynamically changing file name ?
21. How to include customized header and footer text for a flat file target?
22. What is session partitioning and how can we load 10 same structure flat file parallely in a single pipeline? 23. What is the use of Push down optimization and what are the limitation or preconditions for PDO?
24. Explain the different types of SCD implementations?
25. What is SCD type 6 approach?
26. What is star schema and Snowflake schema?
27. What is the use and syntax of Mass Update, PMCMD and PMREP commands ?
28. Explain transaction control transformation with an example ?
29. What are the methods of code migration from one environment to another environment?
30. Explain the complete process of a workflow run and task performed by Integration service, DTM buffer and all other process threads?
31. If suppose I have a workflow where there are two sessions linked in series, what needs to be done to run the second session only seventh time (weekly once)?
32. How to send a mail when the session starts loading to target?
33. How to handle multiple delimiters in a single file?
34. How will you recover an object which is accidentally deleted?
35. What is process of running multiple instances of a single workflow?
Please mail to jalal.jc@gmail.com for solution of any above question or post your comment/query here..:)
2. How many types of fact and dimension tables are available?
3. What is fact-less fact table ?
4. How lookup is active in informatica 9.1 and what is the additional option added to lookup ?
5. How to update a table without update strategy or a table which does not have a primary key ?
6. What is the difference between lookup and joiner ?
7. What happens if we select all the port of an aggregator or if we dont select any port for group by?
8. What will be the output of a group of a router where no condition is given?
9. What are the limitations of a joiner ?
10. Is Union transformation in Informatica same as Union in Oracle? How to do the same as Oracle Union in Informatica?
11. What is GK_ID and GCID in Normalizer ?
12. Explain the use of Newlookup port in Dynamic lookup ?
13. What is the use of MD5 function in informatica?
14. Explain Incremental aggregation with a scenario ?
15. How to declare a mapplet variable in parameter file?
16. How to pass a mapping variable from one mapping to another with the help of workflow variable?
17. What is the command we need to use in parameter file to use both session parameter file and workflow parameter file simultaneously? [$PMMergeSessParamFile= TRUE]
18. What is the custom property we need to set in order to ignore new line character in between the data enclosed within quote? [ MatchQuotesPastEndOfLine=Yes]
19. Give an example of Informatica user defined function ?
20. How to handle Event Wait task for dynamically changing file name ?
21. How to include customized header and footer text for a flat file target?
22. What is session partitioning and how can we load 10 same structure flat file parallely in a single pipeline? 23. What is the use of Push down optimization and what are the limitation or preconditions for PDO?
24. Explain the different types of SCD implementations?
25. What is SCD type 6 approach?
26. What is star schema and Snowflake schema?
27. What is the use and syntax of Mass Update, PMCMD and PMREP commands ?
28. Explain transaction control transformation with an example ?
29. What are the methods of code migration from one environment to another environment?
30. Explain the complete process of a workflow run and task performed by Integration service, DTM buffer and all other process threads?
31. If suppose I have a workflow where there are two sessions linked in series, what needs to be done to run the second session only seventh time (weekly once)?
32. How to send a mail when the session starts loading to target?
33. How to handle multiple delimiters in a single file?
34. How will you recover an object which is accidentally deleted?
35. What is process of running multiple instances of a single workflow?
Please mail to jalal.jc@gmail.com for solution of any above question or post your comment/query here..:)
I will Provide the Answers very soon... plz provide your feedback...
ReplyDeleteAre the answers provided somewhere?
DeleteFew are here as comments...plz let me know if you need any help on any que...
Delete33. How to handle multiple delimiters in a single file?
ReplyDeleteSol:
1. Open Flat file source in Powercenter designer and double click on it.
2. Goto Advanced file properties.
3. In Column Delimiter placeholder, list all the delimiters (i.e. $|~@).
4. Uncheck the property “Treat multiple delimiters as AND”
N.B. If this option is checked Integration service will look for a delimiter token “$|@~”; and the data eventually endup putting all the columns under one data column; So, to avoid the mentioned risk always ensure to turnoff this property
5. Click OK to save the changes
35. What is process of running multiple instances of a single workflow?
ReplyDeleteSol:
Please visit the below link where the same is explained in a superb way.
http://www.disoln.org/2012/11/Informatica-Concurrent-Workflows-to-Reduce-Warehouse-ETL-Load-Time.html
My Source table has 1million records, I am using a joiner transformation. Whether using sorted input option in joiner with a sorter transformation prior to joiner in the pipeline will increase the performance
ReplyDeleteYes, If you are having heterogeneous source than sort the data at SQ level and use joiner transformation which will increase the performance to some extent. But, for homogeneous source its better to use Source query override to perform the join other than using a sorter and joiner transformation. Plz let me know for further doubts.
Deletenice one sir
ReplyDelete