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,

2249

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 11803

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 6009

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

CSC,

7 9232

Are there any types of Dynamic Caches in informatica

Accenture,

4 6945

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 6637

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 8571

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 7538

what is INFORMATICA TESTING process

1678

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 3439

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

1577

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

TCS,

4 20706

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

TCS,

2 5998

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 3973

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

HCL, TCS,

2 11773


Post New Informatica Questions

Un-Answered Questions { Informatica }

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1652


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

525


Which transformation is needed while using the Cobol sources as source definitions?

558


What do you mean by channel change?

401


permutations of mapplet

1828






How can we improve session performance in aggregator transformation?

516


Explain the aggregator transformation?

469


WHat all joins are there in Source Qualifier?

412


What are some examples of informatica etl programs?

391


Differentiate between source qualifier and filter transformation?

739


How can a transformation be made reusable?

527


my source is junk data how will u remove that junk data by using unix please any one replay me

3060


How to use procedural logic inside infromatica?

477


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5291


What are the informatica performance improvement tips

458