Answer Posted / deepesh bhatnagar
Decision Stream(IBM Cognos)
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Mention some types of transformation?
Explain lookup transformation in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to generate sequence numbers without using the sequence generator transformation?
Explain what are the different types of transformation available in informatica.
What is blocking transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Does an informatica transformation support only aggregate expressions?
What is Index Caches size?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is a joiner transformation and why it is an active one?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to use pmcmd utility command?