Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

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

TCS,

2990

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 15006

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 8083

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

CSC,

7 12540

Are there any types of Dynamic Caches in informatica

Accenture,

4 8849

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 8629

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 11332

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 9104

what is INFORMATICA TESTING process

2290

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 4747

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

2271

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

TCS,

4 23669

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

TCS,

2 7449

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 4973

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

HCL, TCS,

2 14007


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is decode in static cache?

1179


What is workflow monitor?

1062


What is the use of an aggregator cache file?

1199


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237


If informatica has its scheduler why using third party scheduler?

1268


What can we do to improve the performance of informatica aggregator transformation?

1095


How many input parameters can exist in an unconnected lookup?

1545


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107


How can informatica be used for an organization?

1220


What is rank index in rank transformation?

1080


During the running session, output files are created by informatica server. Enlist few of them.

982


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058


What is the use of code page?

1094


What are the modules in Power Center

1680


What are the differences between joiner transformation and source qualifier transformation?

1171