Interested to Buy Any Domain ? << Click Here >> for more details...
i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need
- 7 Answers
- 25897 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / srikanth
Source Qualifier transformation applies to only for
databases and not for flat files (upto versoin 7.x) but i
have no idea on later versions.
It just acts like a label and we cant configuare or use any
of the properties in source qualifier if the source is flat
file.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the advantage of informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
COM components can be used in Informatica
What are the informatica performance improvement tips
Is it possible to define a single node as a Gateway node as well as worker node?
Write the unconnected lookup syntax and how to return more than one column.
How does the aggregator transformation handle null values?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Clarify the utilization of aggregator cache record?
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
How can we improve session performance in aggregator transformation?
How might you approve all mappings in the archive all the while?
what is the size of u r source(like file or table)?
Explain the tuning lookup transformation - informatica
What is xml source qualifier transformation in informatica?
