Define pmcmd command?
No Answer is Posted For this Question
Be the First to Post Answer
Quickly characterize reusable change?
During the running session, output files are created by informatica server. Enlist few of them.
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
How can we integrate different flat file data in a single mapping and with in a single execution
Why do we need informatica?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Can we get 1st record through Informatica(without sequence number).
To import the flat file definition into the designer where should the flat file be placed?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What is the need of building a data warehouse?
how can you load data into target table without leading zeor's