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

Write the unconnected lookup syntax?

1085

Write the unconnected lookup syntax and how to return more than one column.

1112

How do you remove duplicate records in informatica? And how many ways are there to do it?

1168

What is dimensional table? Explain the different dimensions.

1174

What are the types of caches in lookup?

1052

What are the types of caches in lookup? Explain them.

971

Differentiate between router and filter transformation?

1016

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1711

What are the differences between oltp and olap?

973

What are the types of schemas we have in data warehouse and what are the difference between them?

944

Differentiate between reusable transformation and mapplet.

1101

Why update strategy and union transformations are active?

1046

What is meant by target load plan?

975

How to join three sources using joiner?

1119

How do you update the records with or without using update strategy?

1118


Post New Informatica Questions

Un-Answered Questions { Informatica }

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1679


What is lookup transformation?

1042


Quickly characterize reusable change?

1124


How to load the data from a flat file into the target where the source flat file name changes daily?

1066


wf dont have integration severances how you can run?

1941


What is a dimensional model?

986


What is dimensional table?

1070


What does role playing dimension mean?

1048


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2186


How to start a workflow using pmcmd command?

1256


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2726


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2070


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1041


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2129


design of staging area?

2030