can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 24352 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / guddu kumar mehra
We can not update a record in a flat file as we need a Key column to update the record but in flat file we can not have a key column.
So we can not implement SCD type 2 on flat files.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
Where do we use mapping variables in informatica?
how we can load rejected record's at run time?(not through bad files)
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain about cumulative Sum or moving sum?
Describe data concatenation?
Tell me about Propagate functions in informatica
What is joiner transformation in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is deployment group?
Which files are created during the session rums by informatics server?
Can u generate reports in Informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Can we get 1st record through Informatica(without sequence number).
can anyone suggest best free Talend data integration training online
