Interested to Buy Any Domain ? << Click Here >> for more details...
for ex: in source 10 records are there with column sal. use
a filter transformation condition as Sal=TRUE and connect
to target. what will happen.
- 11 Answers
- 22603 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / shiva
nothing will happen when we use filter option it just check
the source record where all record are salary records or nor
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the Rank index port in Rank transformation?
Explain the different lookup methods used in informatica?
What is a difference between complete, stop and abort?
How to convert multiple rows to single row (multiple columns) in informatica
What is union transformation in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to load the data from a flat file into the target where the source flat file name changes daily?
How to use procedural logic inside infromatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can we create multiple integration service on single repository?
How many ways are there to do 'remove duplicate records in informatica'?
Under what condition selecting sorted input in aggregator may fail the session?
