What is source qualifier transformation?
Answer / swetha
When yoU add a relational or a flat file source definition
to a maping, yoU need to connect it to a source qualifer
transformation. The source qualifier transformation
represnets the records that the informatica server reads
when it runs a session.
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you load only null records into target? Explain through mapping flow.
What is a repository manager?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
What does refresh system mean, and what are its distinctive choice?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
What are the advantages of using informatica as an etl tool over teradata?
What is informatica? Why do we need it?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
what is Partitioning ? where we can use Partition?