What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?
Please answer below. thank you.
Answer Posted / me
If you use sorted input and do not sort data correctly, the session fails.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What do you mean by filter transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
whats the logic to load the lower level of granularity of data to fact table.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Which are the different editions of informatica powercenter that are available?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What does role playing dimension mean?
Whats there in global repository
what is the hint? how to use it to reduce the query processing in program?
generate date / time dimension in informatica
How many transformations can be used in mapplets.
Tell me about MD5 functions in informatica
Is stop and abort are same in informatica?