suppose in my source flatfile i have 10000 records in that
some of master table records missed table records missed
then what will u do
No Answer is Posted For this Question
Be the First to Post Answer
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
What are the different options used to configure the sequential batches?
diffrence between command task and control task
How do you do error handling in Informatica?
Kimball and Inmon methodologies?
can we load the data with out a primary key of a table? what is target plan?
What is depict expression change?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Explain what transformation and how many are there in informatica?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.