What is the difference between unicode & ascii mode data
movement in informatica?
Answer / ravi
unicode data movement reads 8 bits at a time where as ascii
reads character by charecter
| Is This Answer Correct ? | 12 Yes | 5 No |
what is diff b/t sorter t/r and agg have the option sorter property...
How does a rank transform differ from aggregator transform functions max and min?
what are the different types of transformation available in informatica and what are the mostly used ?
How You Pull the records on daily basis into your ETL Server.
What is operational data source (ODS)?
what is the diff b/w union and joiner and lookup?
Why the workflow is failed after running two hours in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
what is mean by complex business rule ?
can we use bulk loading when we use look in mapping