Interested to Buy Any Domain ? << Click Here >> for more details...
if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
- 7 Answers
- 22643 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / saradhi
i think its thorws an error
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
Informatica Checkpoints
What are junk dimensions?
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?
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
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is InformaticaPowerCenter?
What are the differences between oltp and olap?
How to update or delete the rows in a target, which do not have key fields?
What is the difference between a connected look up and unconnected lookup?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is transformation?
How do you handle two sessions in Informatica
According to his methodology what all you need before you build a datawarehouse
Why is sorter an active transformation?
