Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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?

350

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

371

What is xml source qualifier transformation in informatica?

412

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?

484

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

352

What do you understand by term role-playing dimension?

365

What is parallel processing in informatica?

482

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

358

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

1 446

WHat all joins are there in Source Qualifier?

368

What all join we can perform in LOOKUP transformation?

344

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

356

Different circumstance which drives informatica server to expel records?

334

Separate from an archive server and a powerhouse?

326

Make a note of the quantity vaults made in informatica?

328


Post New Informatica Questions

Un-Answered Questions { Informatica }

tell me the rules and responsblites in our project(my project is development)

1279


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

381


Explain what are the different versions of informatica?

403


What are the types of lookup transformation?

431


What is the sql query overwrite in source qualifier in informatica

407






What is sq transformation?

385


What is the difference between informatics 7x and 8x and what is latest version?

346


Plz can any one say me how to get the informatica certification materials and dumps

1382


Did u used latest transformations of 8.6.0? for what?

1283


tell me about your project functionality

1659


What is complex mapping?

386


Explain the scenario which compels informatica server to reject files?

401


What does role playing dimension mean?

398


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

362


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

7056