Interested to Buy Any Domain ? << Click Here >> for more details...
i have source file data empno,ename,sal 100,ram,1000
200,tyu,2000 300,gh,3000 out put as e
empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
- 5 Answers
- 9640 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sameer
1) Connect the source Qualifier to expression transformation.
2) In the expression transformation create a variable port V_count and increment it by one.
3) Create V_sal variable port and assign the expression IIF(V_count=1,NULL,V_prev_sal) to it.
4) Create one more variable port V_prev_sal and assign Sal to it.
5) Now create output port O_prev_sal and assign V_sal to it.
6) Connect the expression transformation to the target ports.
In the expression transformation, the ports will be
empno, ename, sal
V_count=V_count+1
V_sal=IIF(V_count=1,NULL,V_prev_sal)
V_prev_sal = sal
O_prev_sal = V_sal
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Explain sessions?
list out all the transformations which use cache?
What all are steps in up gradation of Informatica server?
What is an expression transformation in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is a router transformation?
What is aggregator transformation in informatica?
have u done any performance tuning? how u ll do?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the static cache and dynamic cache in informatica?
what is the size of u r source(like file or table)?
How can we remove the duplicates from flat file source?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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
What is depict expression change?
