source target
Q410 4 2010
Q311 3 2011
Q412 4 2012
Q309 3 2009
- 1 Answers
- 3551 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kiran
source-sq-exp-tgt
in exp take two new ports
o1- substr(string,2,1)
o2-concat('20',(substr(string,3)))
let me know if i m wrong
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
How to generate sequence numbers using expression transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Do you find any difficulty while working with flat files as source and target?
What is the use of an aggregator cache file?
I have a flat file, want to reverse the contents of the flat file
How is union transformation utilized?
Explain sessions and how many types of sessions are there?
What is joiner transformation?
Explain in detail about scd type 1 through mapping.
What are the different versions of informatica?
Differentiate between joiner and lookup transformation?
How can a transformation be made reusable?
How do you take back up of repository?
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 .
