-
How to load the dimension tables from staging areas?
anupama2000
- May 26th, 2008
We need to create them in warehouse designer according to specification and move them to another folder where you can use that as target by generating them in warehouse.
-
How do to detect every day delta changes?
priyank_divya
- Jul 9th, 2012
Hi,
We can capture the delta changes by using a look up transformation followed by an update strategy transformation with which can insert,delete and update records.
Thanks. -
-
Informatica : set statement in update
Need to update the existing records,The record which is coming for update should be inserted and also the previous record's one column must be modified. i have used look up to look up the data.used router to separate the data for insertion and update.Used expression to calculate something on those new records for update.service_code valid_startdate valid_enddate01 2003-03-03...
anu_v_iitd
- Dec 13th, 2007
Actually what need to be done here is:You need to use two update strategy transformation just before inserting or updating the data into target table, Obviously there will be two instances of target t...
-
What is Incremental Aggregation?
chandrarekha
- Feb 5th, 2008
When u enable the incremental aggregation ,it passes all the source rows to the mapping and uses the historical cache to perform the aggregate calculations
-
Informatica Working with flat files
How can we display delimiters beside column names of target flat file?
komalahanumantharao
- Dec 26th, 2007
While creating the targets using flat files we will get a options to specify whether the flat file is delimited of fixed length following tht steps in one of the steps we get how to notify the delimiters in the flat file there we can adjust delimiters beside the target columns name
-
IQD file
What is IQD file?
Kalpana gopinath
- Jan 14th, 2008
In Cognos u will have impromptu (reporting tool) in this all the report will be stored as report.IMR which is one dimensional (single view ) report .but when we want to build cubes&n...
-
Apply Business Rules
Where do we apply business rules from souce to staging or staging to warehouse?
Amritendra kumar
- Feb 29th, 2008
Actually we don't apply business rule . we only treat the data according to the business rule and in this work we get help by business analyst. in staging area we generally do cleansing ...
-
Mappings and Production Server?
How to move the mappings to the production server?
sekhar7791
- Jan 18th, 2008
HiFrist export the mapping, it will create a xml file and connect to production repository there import that xml file.Sekhar7791
-
What is intermediate task in informatica? In what situation this task will be executed?
-
Assignment task in informatica
What is Assignment task in informatica? In what situation this task will be executed? Where this task exits?
mdahiya81
- Feb 6th, 2008
The Assignment task allows you to assign a value to a user-defined workflow variable. To use an Assignment task in the workflow, first create and add the Assignment task to the workflow. Then config...
-
Which transformation useful for joining the multi table..........
I am retrieving the multi structures from source i want to define single target table structure for this which transformation i need to follow
-
ETL Design Complex Logic
What is the most complex logic you have used in your ETL design?
-
How to link informatica with database (oracle or sql server)
Hello,could anyone please guide me ,how to link with database(oracle database or sql server),iam new to informatica, please tell me the path to link these 2 because iam practising in my homewith my computer.please anyone help me.rkumar_123thanks in advance
manojkumarkurnool
- Feb 13th, 2008
hi to all infomatica people in order to link infomatica with database an infomatica developer or etlconsutant has to use ODBC Connections (open database connectivity driver)which are their in infomati...
-
Upgrading the mappings from Informatica 7.1.3 to Informatica 8
What are the advantages and disadvantages (if any) of upgrading the mappings from Informatica 7.1.3 to Informatica 8
raj_infadev
- Oct 13th, 2008
hi thereits not the matter of advantages or disadvantages for upgrading. its all depends on client requirement. if the client feel that using higer version is more comfortable and ease of use and...
-
Run sessions
How do you run sessions one after another?
pal.amol
- Feb 25th, 2008
There are two methods for running the session one is to run concurrently and second one is to run sequentially which you want to do. There are three things need to be configured at properties lev...
-
Sorter in Active Transformation
Why is sorter an active transformation? What happens when you uncheck the DISTINCT option in sorter?
MMSheriff
- Feb 27th, 2008
Sorter is an active transformation since it eliminate the duplicate records when the distinct option box is checked.The uncheck distinct option will lead to show duplicate records
-
Informatica Dynamic Source and Target
Similar to creating dynamic target can we create dynamic source?
-
Use VSAM file as Target in Informatica
Is it possible to have VSAM file as target? If yes can you suggest me how this can be done?
aniban
- May 10th, 2008
I believe (although not 100% sure) that this is possible. Several years back in one of the projects we had used a tool called STRIVA which could directly read/write in the form of VSAM files. Lately I...
-
Delete Informatica repository
I am using Informatica 7.1.1, How to delete the existing repository, mappings?
hasim_geek
- Jun 6th, 2008
To delete repository- Delete it from Informatica Server Administrative ConsoleTo delete Mapping - Delete it from designer.To delete folder - Delete it from Repository Manager.
Informatica Interview Questions
Ans