-
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 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 can we delete duplicate rows from your source in mapping without using SELECT DISTINCT option in source qualifier?
hemachandra
- Dec 26th, 2007
Also you can use group by on all columns you are pulling either by sql override or aggrigator
-
How many repositories can we create in Informatica?What is aggregate awareness?What are parallel queries and query hints
hemachandra
- Dec 26th, 2007
Query hints are used in RDBS concept, when you write SQLs in pervious days developer use give hint points while writing the query for DB engine, they are called rule based DB, now the rule based DB is fading out in the market, these days youwill find all new DBs as cost based
hemachandra
- Dec 26th, 2007
Aggregate awareness is the method in Business Objects while creating measures in the universe, it is process where you define the aggregation strategy which you wanted BO to follow, useful mostly for Drill downs based on different dimentions
-
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
-
In which particular situation we use unconnected lookup transformation?
sridhar39
- Dec 28th, 2007
hi, both unconnected and connected will provide single output. if it is the case that we can use either unconnected or connected i prefer unconnected why because uncon...
Tarun Vig
- Oct 12th, 2007
Use of connected and unconnected Lookup ic completely based on the logic which we need.However i just wanted to clear that we can get multiple rows data from an Unconnected lookup also.Just concatinat...
-
Explain Session Recovery Process?
sridhar39
- Dec 29th, 2007
hi, when the informatica server starts a recovery session it reads the opb_srvr_recovery table and notes the r...
chandrarekha
- Sep 28th, 2007
You have 3 steps in session recoveryIf Informatica server performs? no commit, run the session againAt least one commit, perform recoveryperform recovery is not possible, truncate the target table and run the session again.Rekha
-
Explain pmcmd?
sridhar39
- Dec 29th, 2007
hi PMCMD means program command line utility. it is a program command line utility to communicate with informatica server. &...
chandrarekha
- Sep 28th, 2007
It a command line program. It performs the following tasksStart and stop the session and batchesStop the Informatica ServerChecks whether the server is working or not
-
How to append the records in flat file(Informatica) ? Where as in Datastage we have the options i) overwrite the existing fileii) Append existing file
dl_mstr
- Jan 2nd, 2008
Write a post_session command in the session.For example : COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv
sm1506
- Apr 7th, 2006
this is not there in Informatica v 7. but heard that its included in the latest version 8.0 where u can append to a flat file. Its about to be shipping in the market.
-
How to append records in flat file using Informatica?For eg : In Datastage we can append the records in flat file(sequential file) using the options i) overwrite the existinf file.ii) Append the existing file.
dl_mstr
- Jan 2nd, 2008
Write a post_session command in the session.For example : COPY C:PreviousFinaloutput.csv+C:newflatfilerecords.csv C:PreviousFinaloutput.csv
promila
- Jul 17th, 2007
HI , We can use /n as a delimiter to append data at the bottom and also checking the option - append in the workflow monitor . but i am not clear can we append data at the top . One way is to create&n...
-
Informatica source and targets with same fields
We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd row in source should go to 3rd target, 4th row again to 1st target , 5th row to target2 6th row to target 3 like this we need to transfer data how is it possible?
sandeep.vaishy
- Jan 14th, 2008
First Load Data from source To One dummy table in target with SEQ Gen T/R.in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option.It will load the data with new column Values 1,2,3,1...
sekhar.ganta
- Jan 3rd, 2008
here we should use router transformation with 3 groups. suppose 3 targets are target1: condition multiples of 3?????????? select * from emp where (empno,0) in (select empno,mod(rownum,3) fro...
-
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...
-
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
-
How many types of facts and what are they?
senthilkar
- Jan 22nd, 2008
1. Regular Fact - With numeric values2.Factless Fact - Without numeric values
shiva
- Oct 30th, 2006
haithere r three types of factsAdditive Fact-Fact which is used across all dimensionssemi Additive Fact- Fact which is used some dimesion and not with some Non Additive Fact- Fact which is not used any of the dimesion
-
What types of Errors occur when you run a session, can you describe them with real time example
kasisarath
- Jan 25th, 2008
There are several errors you will get. Couple of them are1. if informatica failed to connect data base2. If source file not eixsts in location3. If paramerters not initilized with parameter file4. incompataible piped data types etc.
-
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
-
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
-
What happens if cache name is not entered in the lookup ?
-
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...
-
Data profiling
1.)I am creating custom profile on the relational source because it is failing to create report due database fatal error (some table name pm_dp_m doesn't exists in the repository) but when i check the repository there r 247 tables created?pls help me 2. Pls anybody tell me how deploy the mappings workflows,sessions created at the development site to production site in real time? thanks in advance
Informatica Interview Questions
Ans