IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
Answer Posted / saritha
You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
How to elaborate powercenter integration service?
How identifying bottlenecks in various components of informatica and resolving them?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to convert multiple rows to single row (multiple columns) in informatica
update strategy transformation in informatica
what is index?how it can work in informatica
Which transformation should we use to normalise the COBOL and relational sources?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What does command task mean?
How would you copy the content of one repository to another repository?
As union transformation gives UNION ALL output, how you will get the UNION output?
can any one give some examples for pre sql and post sql(Except dropping and creating index).