Un-Answered Questions { Data Warehouse }

Code check-in and check-out commands in AbInitio

3349


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?

528


How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

463


How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

644


Runtime behavior of Normalize and Reformat

1705


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.

511


Difference between output_index and output_indexes in reformat

747


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)

508


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

363


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

453


Intern stastical programmer written test

274


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

337


Tell me about MD5 functions in informatica

513


Tell me about Propagate functions in informatica

515


How to update a particular record in target with out running whole workflow?

1148