Interested to Buy Any Domain ? << Click Here >> for more details...
Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
- 1 Answers
- 7643 Views
- Infosys, I also Faced
- E-Mail Answers
Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.
| Is This Answer Correct ? | 6 Yes | 2 No |
major difference between normal loading and bulk loading?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Is stop and abort are same in informatica?
What is the difference between normal and bulk loading? Which one is recommended?
What do mean by local and global repository?
Explain sessions. Explain how batches are used to combine executions?
Without using Lookup & Sequence Generator, How to generate Sequence?
where to store informatica rejected data? How to extract the informatica rejected data?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Teradata 
