what happens if you try to create a shortcut to a non-
shared folder?
Answer / krishna
If you try to create a shortcut to a nonshared
folder, the Designer creates a copy of the object instead.
| Is This Answer Correct ? | 4 Yes | 1 No |
why dimenstion tables are denormalized in nature ?
what is junk dimension
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the conditions needed to improve the performance of informatica aggregator transformation?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Which transformation should we use to normalise the COBOL and relational sources?
What are the different types of Type2 dimension maping?
what is runtime variable?