-
How do I pass a argument retrieved from a mapping to a command task?
In a unix environment I have an application that takes several arguments. One of these I get from a session mapping. How do I pass this argument into my application?
-
What is Meta Data in prospects of Informatica?
DK_Reddy
- Apr 19th, 2009
Informatica Repository Server Holds some data for Mapping transformations and after modifications(Calculations) that data will move to target (as per client requirement)This data will call as Metadata.?
-
What is pre-session and post-session?
vizaik
- Nov 14th, 2007
Pre-session:Before executing session, this pre-session command executesPost-session:After the completion of execution of this session, the script in the post-session runs.
-
-
How can we know whether data is changed from last time to this time?How can we identify the whether data is changed or not.
komalahanumantharao
- Dec 26th, 2007
By using the typeII mapping i.e. we use a seperate flag key which keeps changing when we changet the date in the table
-
How to use incremental loading when you load data from staging?
nandu214
- Jun 17th, 2008
HiFirst u run initial laod with startdate and enddate next take enddate as startdate for incremental loading it wil add the data for previous like this we can do incremental loadingHope this helps
-
-
What will be the output?Select 'a' from table1 UNION select 1 from table2;
gdngajudn
- Nov 29th, 2007
Execution of this query will give an error.We will get error in this Case as the the out put for table 1 is a string where as the the return of table 2 is a number and both are of different datatype.
-
What is the difference between ODBC , DSN , NATIVE and TCP/IP Connections?
komalahanumantharao
- Dec 26th, 2007
ODBC is the database drivers which is used to connect from clinet to the relational database.DSN is the data service name which is thename of the odbc name give by the customer inoreder to...
-
How to delete data from target table before insert starts without using truncate option in MappingThanks,
ajmani
- Dec 5th, 2007
This can be done by a pre sql script in the session.simply go to session->mappings->target.there in presql script give truncate table tablename.
-
How can we append the data coming from multiple sources which dont have any relations into the flat file target which already exists and has data.
komalahanumantharao
- Dec 26th, 2007
First we should generate theWarehouse key using sequence generator and insert the rows into the target using update strategy
-
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
Informatica Interview Questions
Ans