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

Post New Answer

More Informatica Interview Questions

Why is meant by direct and indirect loading options in sessions?

4 Answers  


Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  


write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,


how many types of dimensions are available in informatica?

0 Answers  


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  






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)?

1 Answers   iNautix,


why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,


when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


Explain in detail about scd type 1 through mapping.

0 Answers  


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  


What are Rapid changing dimensions?

1 Answers  


Categories