1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

i have two source data there is no pk,fk how to join the two sources

TetraSoft,

5 9674

diffrence between command task and control task

iNautix,

1 6414

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

Wipro,

3 5824

is it possible to index the data in cache of lkp transformation ?

 1513

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

 3 6057

how can import the data from the flat files?

 2 4971

major difference between normal loading and bulk loading?

 6 10449

explain about session partitions ?

 1 5028

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

TCS,

5 7092

if we have a delimiters at unwanted places in a flat file how can we over come those.

 1560

what is the hint? how to use it to reduce the query processing in program?

Cegedim,

3 6269

Can I create one wrkflw which will run different wrkflws on schedule time?

 3 5416

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

TCS,

2 5769

what is song in infrmatica...?

CTS,

1661

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

TCS,

3 9081

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to join three sources using joiner?

557

What is rank transform?

591

Explain why we use partitioning the session in informatica?

601

How can we use mapping variables in informatica? Where do we use them?

611

What are the different lookup cache(s)?

611




How do you set a varible in incremental aggregation

1432

In informatica workflow manager, how many repositories can be created?

771

What is expression transformation?

620

Describe the impact of several join conditions and join order in a joiner transformation?

632

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2267

What is resilience time?

647

What is the function of look up transformation?

639

waht type of interface is used for testing the data in informatica

1825

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1038

What is meant by lookup transformation?

601

For More Un-Answered { Informatica } Questions Click Here