Un-Answered Questions { Data Warehouse }

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?

532


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

470


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

651


Runtime behavior of Normalize and Reformat

1720


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.

515


Difference between output_index and output_indexes in reformat

749


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)

521


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

367


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

461


Intern stastical programmer written test

282


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

346


Tell me about MD5 functions in informatica

519


Tell me about Propagate functions in informatica

520


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

1152


How you prepared reports for OLAP?

1149