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

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

iFlex, TCS,

2 9378

How could we generate the sequence of key values without using sequence generator transformation in the target ??

TCS, Tech Mahindra,

12 38608

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 39182

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

Virtusa,

4 13170

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 6281

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 6559

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 56868

Without using any transformations how u can load the data into target?

IBM,

15 25150

what is casual dimension?

IBM,

6 19359

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 96430

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

IBM,

4 11762

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

2123

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 4412

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

2 24003

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

Satyam,

2 18067


Post New Informatica Questions

Un-Answered Questions { Informatica }

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

2294


What are the prerequisite tasks to achieve the session partition?

1300


What is the difference between a connected look up and unconnected lookup?

1005


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2194


Implementation methodology

1776


Different sorts of metadata that stores in the storage facility?

1076


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2164


What is option by which we can run all the sessions in a batch simultaneously?

1198


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

1115


What are multi-group transformations?

1165


What is expression transformation?

1148


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2314


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2204


How might one distinguish in the case of mapping is right or not without associating session?

1197


Explain lookup transformation is active in informatica

1152