How to create or import flat file definition in to the warehouse designer?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,


is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,


Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  


What are the tasks that can be performed using sq?

0 Answers  


Differences between connected and unconnected lookup?

0 Answers  






Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  


My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,


have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


What is hash partition?

2 Answers  


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


Categories