-
What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?
suneetharoy
- Oct 23rd, 2009
Pre SQL: The SQL query fires initially when loading to that database.Example for Pre SQL: Suppose my requirement is to load the records daily. If some updates I have to reload the records for that pa...
sekhar.ganta
- Jan 3rd, 2008
I think above answer may be not correctIn source qualifier t/r : If you write any pre sql? that statement will execute is source database connection before reading the data. If you write that query?...
-
Informatica - connect to the repository server error
I am unable to connect to the repository server in repository administrator console after registering new server
anupama2000
- May 26th, 2008
Hi,SOGOTO SERVICES BYRUN-->TYPE( SERVICES.MSC)START THE INFORMATICA SERVER AND NOW CONNECT IN REPOSITORY SERVER ADMIN CONSOLEOR CHECK THE PAASWORD THAT U HAVE GIVEN FOR REP SERVER
sakthione
- Dec 30th, 2007
Hi friend!Please follow these steps and try to connect the server; My computer properties &nbs...
-
Informatica objects File Format
What is the file extension and format of the files for the Informatica objects like Mappings, sessions etc in the repository ?
virendra.jaipur
- May 21st, 2010
If you store them in repository, it obvisouly is in terms of relational tables.But if these objects are stored/exported outside the repository, as files; that is when they are stored as xml format files.
sameer_solidcore
- Feb 20th, 2009
Repository is nothing but a database, rather a relational database, and in a relational database anything and everything is stored in tables. And tables are nothing but files with pointers. So in a re...
-
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...
-
Connect two sources
How to connect two sources with connecting field without using joiner and lookup?
-
Mapping variable - Mapping Parameter
What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?
garunchowdary
- Feb 29th, 2008
Definitely it accepts the defualt values when parameters or variables are not present.
sarun5
- Feb 18th, 2008
Thanks Deepak. But does it take any null values or any default values to run the mapping.
-
What is meant by source is changing incrementally?
What is meant by source is changing incrementally?Explain with an example?
N SRIRAM K
- Apr 14th, 2008
The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....ThxSRIRAM N
Vani_AT
- Mar 28th, 2008
I think, source is changing incrementally means new rows are getting inserted into the source. For example, If a source on day1 has 10 records; then on day2, 5 new records got added along with the pre...
-
Dimension Tables and Fact Table
How many Dimension tables can connect to a Fact table?
jryan999
- Sep 1st, 2008
The number of Dimensions depends primarily on the requirement. I have built systems with a few FOUR Dimensions on a Fact and as many as TWENTY. There is no physical limit imposed by either...
subashreddy77
- Apr 27th, 2008
Hiwe can connect as we like but it will be generally based on requirements
-
Main data object in between Source and Target
What is the main data object present in between Source and Target.
N SRIRAM K
- Apr 14th, 2008
Stage..where we can transform the source data and will load into TGT.Thx SRIRAM N
-
Cached Lookup and an Uncached Lookup
What is the difference between using a cached lookup and an uncached lookup?
gaurav2485
- Jan 8th, 2009
In Cache Lookup a cache will be created of that Lookup table and IS query once for mapping rows for Uncache lookup No cache will be build and IS query for each Mapping rows.So for performance Go for C...
ggazulas
- May 27th, 2008
For a cached lookup the entire rows (lookup table) will be put in the buffer, and compare these rows with the incomming rows.where as uncached lookup, for every input row the lookup will query the lookup table and get the rows.
-
How does Informatica get sources from IBM MQ Series
-
Load data from a pdf to a table using informatica.
Can we load data from a pdf to a table using informatica.
adilshariff
- Sep 16th, 2008
Yes, you can load data from a pdf to a table using UDO[Unstructured Data Option] Transformation in Informatica from PC811 onwards
balajirajd
- Jul 26th, 2008
Yes we can load, using stored procedure 1. Need to change pdf to excel /.txt formate.2. Call the procedure in the dummy mapping.
-
Relational connection
Hi friends, I connect the pubs database and i move the data to the target successfully. but i connect the Northwind as the same procedure but the task is failed. I don't know what the fault is this? Anyone answer this question please....
Rocksakthi
- Jul 24th, 2008
Thank you very much for your reply savitha. but i already solve the problem. the problem is informatica cannot accept the space in the table name and field name but in the nothwind database if you imp...
-
Update Strategy Transformation
Why the input pipe lines to the joiner should not contain an update strategy transformation?
vijayant.sanjay
- Sep 7th, 2011
Joiner will join two groups of data either homogeneous or heterogeneous, and this join will happen horizontally. One scenario why use of update strategy is prohibited upstream of joiner t/f as below ...
Etl Developer
- May 28th, 2010
This scenario is illogical, First we need to understand the functionality of each repository object.Update strategy: This transofrmation is used to maintain the transaction data based on differen...
-
Multiple Flat Files Loading
If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?
Read Best Answer
Editorial / Best Answer
etluser- Member Since Dec-2009 | Dec 31st, 2009
Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties.
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.priyank_divya
- Aug 3rd, 2012
There is a concept of Indirect filelist for processing multiple files with similar structure.
Rajath
- Feb 20th, 2012
What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n
-
Look override
Explain the suppress comment in lookup override?
khurana29_amit
- May 16th, 2010
If I write the overide query for lookup without order by and "--" at the end then will it take order by from default query?
madhu.tella
- Mar 25th, 2010
Lookup override is nothing but just simply overriding the default sql which is generated by lookup by the runtime, default SQL contains SELECT and ORDER BY caluse and the order by clause ord...
-
Sorted Input option in Incremental Aggregation
Why should not we use sorted input option when using Incremental Aggregation?
jayapraveen
- Oct 4th, 2010
Because of the performance tunning, because here the duplication of the data is sorted in the bginining of the aggregation itself so index cache and data cache ?is reduced so the performance is good.
ahammed
- Jul 21st, 2010
When you are selecting sorted input the data will be sorted and at the same time last record key value will be stored in repository. After that days or months passing on some new records will be ...
-
Lookup Query
What kind of join (Inner,Outer,FULL) does a lookup generate while being used in a mapping in order to search for a particular field value?
prashant.baranwal
- Sep 5th, 2010
When used in mapping, is generates a inner join by default. However when it returns the value to the system, it does returns a NULL for unmatched records. So we can say that it is left outer join. So we must make sure in which context the question is asked.
-
Star Schema
One fact table is surrounded by only one dimension table. Is it star schema or not? Give any real time example?
Rajan Raorane
- Oct 21st, 2010
Fact table surronded by Dimension table in which Dimension table must have primary key and fact table must include foriegn key
srikanthsanga
- Sep 23rd, 2010
Star schema doesn't mean that it has to be surrounded with dimension tables it depends on whether the dimension table have any more relation table to it if it has then it becomes a snow flake schema otherwise its considered as star schema
-
Unconnected lookup
Supose we have 4 column based on same condition can we use unconnected lookup in that case?
Yoganand
- Aug 9th, 2011
Hi,
We can pull any number of columns in unconnected lookup nut with the help of Lookup override. We can concatenate many columns and then use an expression to deconcat those values.
Thanks,
YoganandNagaraju Puppala
- Feb 9th, 2011
Yes it's Possible.Suppose the look up table contains the group values, and the primary is a combination of EMP_NO, DEPT_NO.to get the EMP_NAME from the unconnected lookup, we should pass the EMP_I...
Informatica Interview Questions
Read Best Answer
Ans