What are steps to follow Informatica migration from 7x to 8x?
Pls Explain...
Answer / mithilesh kumar rai
Hi,
Step 1: Export your work and make a .xml file through
Repository Manager
Step 2: and the from designer go with Import option and then
select your existing .xml file and follow the all step
designer asked.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is polling?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Explain the different lookup methods used in informatica?
How many ways a relational source definition can be updated and what are they?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
how to load duplicate row in a target
What is Data Caches size?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?