where we cannot use sorter Transformation. if we use then we
will not get correct data?
- 1 Answers
- 2278 Views
- I also Faced
- E-Mail Answers
Answer / Gourab Kumar
In ETL (Extract, Transform, Load) processes, Sorter Transformation is used to sort records within a data stream based on one or more columns' values. However, it might not be appropriate for transformations where you need to preserve the original order of the records, such as when processing chronological data or maintaining the natural order of a list.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the key benefits of ETL Testing?
what is the meant by Normalization and de-normalization?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
What are snapshots?
Hi, Lookup() is what kind of join ?
what are the different Reporting and ETL tools available in the market?
how do u really know that paging to disk is happening while u are using a lookup transform?
Eliminating of duplicate records without using dynamic lookups
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Two different admin users created for repository are________and_________.
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Teradata 
