Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Runtime behavior of Normalize and Reformat
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
Difference between output_index and output_indexes in reformat
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
Intern stastical programmer written test
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Tell me about MD5 functions in informatica
Tell me about Propagate functions in informatica
How to update a particular record in target with out running whole workflow?
How you prepared reports for OLAP?