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
- 6790 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 the advantage of informatica?
can anyone explain me about sales project in informatica?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
sample mappings for scd1,scd2 and scd3
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
write a query for how to eliminate the duplicate rows without using distinct?
Why we use stored procedure transformation?
What are the new features of informatica 9.x developer?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how tokens will generate?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
Teradata 
