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 will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

933

How does a rank transform differ from aggregator transform functions max and min?

1165

What is xml source qualifier transformation in informatica?

1186

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1116

What differs when we choose the sorted input for aggregator transformation?

985

What do you understand by term role-playing dimension?

1005

What is parallel processing in informatica?

1647

What is meant by lookup transformation? Explain the types of lookup transformation?

909

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 1424

WHat all joins are there in Source Qualifier?

1 2467

What all join we can perform in LOOKUP transformation?

930

Difference between Target-based loading and constraint-based loading?

962

Different circumstance which drives informatica server to expel records?

935

Separate from an archive server and a powerhouse?

919

Make a note of the quantity vaults made in informatica?

953


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain your project of banking domian.

1620


I have a flat file, want to reverse the contents of the flat file

1078


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2343


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9763


How to differentiate between the active and passive transformations?

1103


How can we use batches?

984


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1027


Make a note of the quantity vaults made in informatica?

953


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2090


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8991


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1742


What is a connected transformation?

1066


How do you migrate data from one environment to another?

1065


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1934


Could you explain what is enterprise data warehouse?

1078