Is LOAD MANAGER AND LOAD BALANCER same in informatica?

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 .

0 Answers Amazon,

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers ITC Infotech, TCS,

in what type of scenario bulk loading and normal loading we use?

2 Answers Cognizant, Wipro,

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers Cap Gemini,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers BirlaSoft,

can u give example for factless fact table

2 Answers TCS,

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers IBM,

For more Informatica Interview Questions Click Here