Answer Posted / kumar
source qualifier is a default transformation which reads
data from relational database or flatfile.
we can read data from source
sort data
select distinct data
join data
filter the data
modify sql queries
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
Differences between version 7.x and 8.x.
Enlist the tasks for which source qualifier transformation is used.
What all are steps in up gradation of Informatica server?
can anyone explain me about retail domain project in informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are the uses of etl tools?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is main use of mapplet?
Why do we need informatica?
What is data movement mode in Informatica and difference between them?
whats the logic to load the lower level of granularity of data to fact table.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?