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
- 7801 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / srinu
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 |
Post New Answer View All Answers
What is the use of target designer?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is joiner change?
write a query to retrieve the latest records from the table sorted by version(scd)
Can informatica load heterogeneous targets from heterogeneous sources?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the difference between informatics 7x and 8x and what is latest version?
tell me the rules and responsblites in our project(my project is development)
Differentiate between Load Manager and DTM?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
If informatica has its scheduler why using third party scheduler?
How to load last n records of file into target table - informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
