how to create a sample mapping for dynamic lookup
transformation

Answer Posted / rao

THE BEST EXAMPLE IS SCD-1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In development project what is the process to follow for an etl developer from day1

1271


How to start a workflow using pmcmd command?

707


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

774


How do you manage the Parameter files while migrating your data from one environment to another environment?

536


Separate from an archive server and a powerhouse?

487






If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1547


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

590


In how many ways we can create ports?

697


which one is better performance wise joiner or look up

619


What is the use of source qualifier?

662


What is a repository? And how to add it in an informatica client?

642


As union transformation gives UNION ALL output, how you will get the UNION output?

639


How do you remove duplicate records in informatica? And how many ways are there to do it?

703


What is a difference between complete, stop and abort?

637


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

1728