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

Did u used latest transformations of 8.6.0? for what?

1841

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 7526

what is semi-additive fact?where did u used?

2 5293

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 3877

In dimension and fact table? which one holds big data?

2 6352

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

ACS,

3 7672

scenario

1 4069

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

Amdocs,

1 4550

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

TCS,

3 8151

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

Thomson Reuters,

1 5358

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

Thomson Reuters,

3 13375

can we import source table without using source qualifier? if yes then how? if no then why?

Thomson Reuters,

2 10582

in my source table i want to delete first and last records and load in between records into target? how can it possible?

HCL, Thomson Reuters,

3 9867

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

Thomson Reuters,

6 11696

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

Thomson Reuters,

2 6862


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2038


What is a filter transformation and why it is an active one?

922


What does cheating measurement mean?

1008


What is the status code in stored procedure transformation?

1139


scenario where i can use only concurrent execution of workflow.

3092


What are the differences between oltp and olap?

934


What is standalone command task?

1280


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.

2244


How do you load first and last records into target table?

1116


Separate from an archive server and a powerhouse?

919


Write the different tools in the workflow manager?

1013


What is a node in Informatica?

1010


Explain how to import oracle sequence into informatica?

968


On which transformations you created partitions in your project?

1278


How can we handle two sessions in informatica?

996