source target
Q410 4 2010
Q311 3 2011
Q412 4 2012
Q309 3 2009



source target Q410 4 2010 Q311 3 2011 Q412 ..

Answer / 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

More Informatica Interview Questions

What are junk dimensions?

0 Answers  


What is standalone command task?

0 Answers  


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


what is session parameters?

1 Answers   Cap Gemini,


Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  






What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


Explain about Recovering sessions?

1 Answers  


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


Reusable transformation and shortcut differences

0 Answers  


how to declare array in plsql?

1 Answers  


my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,


Categories