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 the main advantage of unconnected lookup

Cap Gemini,

2 14457

what is junk dimension

Cap Gemini,

4 7264

what is degenerated dimension

Cap Gemini,

6 9860

what is the purpose of surrogate key and diff between primary key&surrogate key

Cap Gemini,

1 6573

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

Cap Gemini,

9 21432

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

Cap Gemini,

5 9905

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

TCS,

3 7620

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 5944

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 4799

what is normalization? explain 1st NF, 2nd NF, 3rd NF

SunGard,

1 11564

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 9336

how will compare two mappings in two different repository?

Real Time, TCS,

2 32143

without using emailtask how will send a mail from informatica?

3 10048

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

IBM, TCS,

5 9123

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

TCS,

5 8685


Post New Informatica Questions

Un-Answered Questions { Informatica }

What do you mean by worklet?

1075


What all join we can perform in LOOKUP transformation?

986


Where are the source flat files kept before running the session?

1087


lookup transformation with screenshots

4008


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

7462


What is Data Caches size?

1095


What is informatica powercenter repository?

1207


Write the program through which the records can be updated?

1010


Why update strategy and union transformations are active?

1051


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

2033


How to use pmcmd utility command?

1041


How can you differentiate between powercenter and power map?

1094


What are the new features of informatica 9.x at the developer level?

1047


wat are deployement groups in informatica, how it will be used for developers

1722


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2282