I need the output file in the below format using Informatica.
__0946684800__
6 1 3 1 5 1 6 1 10 1 6 10
Pos State Time Split AgentID Reason Spaces
Code in Code Spare
state
______ ___ _____ ______ __________ ______
1234 14 0 4321 3103 abcd
4321 15 5 123452 3150
Can someone help please??
We need the data in space-delimited, fixed ASCII format .
No Answer is Posted For this Question
Be the First to Post Answer
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
explain about informatica server architecture?
Describe an informatica powercenter?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
tell me 7.x and 8.x diferrencess(but not transformations)
What is polling?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
what is the diff b/w cached and unchaed look ups
Differentiate between mapping parameter and mapping variable?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What are the modules in Power Center