What are variable ports and list two situations when they can be used?
Answer / thotli
variable port is it stores the variable value after data flow also.
1)when we separate unique records and duplicate values
2)when we develop ranks without rank transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
generate date / time dimension in informatica
What is A cache?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
what is work of PUSH DOWN option
What is a data modeling?
how to work with mapplet designer in informatica?
How i can upload the MainFrame source For Informatica ?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
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
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?