Interested to Buy Any Domain ? << Click Here >> for more details...
can we use lookup t/r in flat files?what are the t/r's can be
used in flat files when compared to relational DB?
- 2 Answers
- 6840 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
1)Yes..you can use a lookup transformation on flatfiles.
2)I think we can use most of the transformations on
flatfiles.
But we can not apply slowly changing dimensions on flat
files.
correct me if i was wrong
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / rajan raorane
No we can apply slowly changin dimensions on flat files
as they are basically used to mantian history
frequently used is SDC2 (Verison/flag/Date)
| Is This Answer Correct ? | 0 Yes | 2 No |
what is system requirement(SR) & business requirement(BR)?
Partition, what happens if the specified key range is shorter and longer
can we override a native sql query within informatica? Where do we do it?
what is the size of u r source(like file or table)?
which transformation uses cache?
how can u avoid duplicate rows in flat file?
What is Performance tuning in Informatica?
Explain the difference between mapping parameter and mapping variable?
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
Design a mapping to load a target table with the following values from the above source?
What's the layout of parameter file (what does a parameter file contain?)?
what is unit testing?tell me proceedure
Teradata 
