Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

What is Java Transformation? what are the uses of it?

TCS,

1977

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

TCS,

7 10003

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

Polaris,

4 5105

If a table contains 100 records we have to fetch 50-100 records from source to target?how

CSC,

7 7799

Are there any types of Dynamic Caches in informatica

Accenture,

4 5895

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

Polaris,

4 5749

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

Accenture,

6 7212

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 6801

what is INFORMATICA TESTING process

1372

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 2867

hi real timers . iam waiting for ur reply regarding ETL TESTING

1249

Can we update a target table (without primarykey) by using update strategy transformation?

TCS,

4 16609

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

TCS,

2 5218

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

TCS,

1 3360

Which one is better performance wise connected/un-connected lkp?why?

HCL, TCS,

2 8872


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is sorter transformation?

163


How do you load only null records into target? Explain through mapping flow.

332


Explain in detail about scd type 1 through mapping.

134


What are the different transaction levels available in transaction control transformation?

197


How to join three sources using joiner?

137






According to his methodology what all you need before you build a datawarehouse

766


What is a surrogate key?

142


What does update strategy mean, and what are the different option of it?

151


Is it possible to define a single node as a Gateway node as well as worker node?

173


what are the deliverables?in your project?

1154


What is informatica etl tool?

131


How identifying bottlenecks in various components of informatica and resolving them?

158


What are the tuning techniques you applied during your last project

1087


How can we create index after completion of load process?

150


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

4356