1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails

tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

Question Posted / isha_gtb


What if i will group by with some port in aggregator and will not pass the sorted values. Will the ..

Answer / hello

In both cases,the session fails

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

How union transformation is used?

0 Answers  

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

1 Answers   Cap Gemini,




WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

what is the monster dimension plz give me one example

2 Answers   EDS,

What is operational data source (ODS)?

7 Answers  

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

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

4 Answers   CSC,

How do you remove duplicate records in informatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories