Interested to Buy Any Domain ? << Click Here >> for more details...
If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?
- 1 Answers
- 6999 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer / akhil4
session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.
| Is This Answer Correct ? | 5 Yes | 1 No |
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
what is correlated query?
Examples of Fatal & Non-Fatal error?
can a port in expression transf be given the name DISTINCT
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Differentiate between a database and data warehouse?
why we are using surogate key in real time give me explanation
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Mention some types of transformation?
Teradata 
