What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
548What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
784What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
1 808Post New Informatica Questions
What is the meaning of up gradation of repository?
How do you use reject loader.
What is the difference between a connected look up and unconnected lookup?
What are the issues you have faced in your project? How did you overcome those issues?
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?
What is substr in informatica?
Explain the difference between a data warehouse and a data mart?
How many ways a relational source definition can be updated and what are they?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is mapplet in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
how to load dimension table and fact table. plz tell me the steps.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a passive transformation?
design of staging area?