-
-
Informatica grid
What is meant by informatica grid? what are the component of informatica grid?
-
-
Joiner Data and Index Cache
Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?
1) 5 fields are in the index cache and 3 are in the data cache.
2) 2 fields are in the index cache and 3 fields are in the data cache.
-
Load 1 crore records into 3 different targets having 25 L records in each?
I have 1 crore record in my table and I have to load 25 Lakh in 1st target, 25L in 2nd target and 25L in 3rd target? How to load 1 crore records into 3 different targets having 25 L records in each?
-
Duplicate Records
If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?
-
Load Last 3 Records using Parameter File
How to load top/last 3 record using parameter file in Informatica?
-
Update Strategy
In which situation do we use update strategy?
-
-
What r the join types in joiner transformation?
Normal (Default) Master outer Detail outer Full outer
-
Informatica error - server service starts momentarily and then stops
I have installed Informatica 7.1.1 and Oracle.But the Informatica server service starts momentarily and then stops.I have uninstalled and installed Informatica twice and removed from the registry as well, but the problem persists.Does any body have the solution for this
-
Event-wait task in Informatica
Which of the following statements is correct on workflow events?
1) A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping.
2) A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon... -
Check Manual Entries in Target Table
I am loading records from a source table to a CRM target table. I want to get the details of the manually inserted, updated, deleted records from the target table. Please explain in detail.
-
What is the default join that source qualifier provides?
Inner equi join.
-
Informatica High Availability check
How to check if the Informatica Power Center is highly available?
-
-
What is use of UNIX in Informatica?
What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?Please tell in details as i am working on windows environment, but will be shifted to UNIX environment. Please describe in details starting from installation of informatica in UNIX to run or guide the working on informatica in Unix environment.
-
Add/Modify Column Changes in Facts and Dimensions
How often do you get Add/modify column changes in Facts and dimensions?
Could you please give me couple real time Datawarehouse Project specific (Day to day work) scenarios?
-
In scd type2
Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?
-
Flat File as Source in Informatica
How can we receive source as flat file in informatica, from where we get this flat file?
Informatica Interview Questions
Ans