-
Sorting Data in SQ and SRT Transformation
What is the difference between sorting data in SQ and SRT transformation?
prashastha
- Nov 12th, 2008
The difference for sorting the data in source qualifier and sorter transformation is that:If your source is relation then you can sort the data in both both transformation.But your source is file then you can only sort those data in Sorter transformation.regards....Prabhu S
-
Tracking Hisroty Data
How can we track history DTA without using Lookup Transformation?
prashastha
- Nov 12th, 2008
Yes it is possible, you can use joiner transformation insted of lookup.In joiner you specify the outer join as source and load the data. regards...Prabhu S
-
How to create a TIME DIMENSION in the Target Database(Oracle)?
There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?
arun.menon
- Oct 24th, 2008
Time and Date dimensions are static dimension. Those are one time activity to populate these tables. It is just the naming convetion used across the projects. If you observe these tables, it will have...
Motilal
- Jun 30th, 2006
Hi Jagadeesh,Can you please mail me with the answer of calling the stored procedure for time dimension.And can have the procedure for time dimension in Oracle..?
-
How to test a Case in Informatica?
mike_in_chicago
- Oct 21st, 2008
I think you want a router transformation... This way you can test if input(s) meet a needed criterion and "route" the records that do to correct targets.In Expression transformation you can test case with nested IIF statements in an expression...
-
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...
-
Where should you place the flat file to import the flat file definition to the designer?
vishal taywade
- Sep 22nd, 2008
We can place source file any where in network, but it will consume more time to fetch data from source file, but if the source file is present on server srcfile then it will fetch data from source upto 25 times faster than previous.
abhishek_upadhyay
- Sep 18th, 2008
Basically the flat file should be stored in the src folder in the informatica server folder.Now logically it should pick up the file from any location but it gives an error of invalid identifier or no...
-
Mapping Parameters
How can we use mapping parameters?
naidubava
- Sep 17th, 2008
Mapping Parameters: Mapping parameter is a constant value which points to any datatype in the entire mapping. its value will not be changed as earlier said. Mapping variable: Mapping variable is same ...
-
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.
-
What is the difference between Enterprise data warehouse and a data warehouse ??Which all transformation uses the cache directory ?
jryan999
- Sep 1st, 2008
I quite agree with the Enterprise Vs Departmental warehouse. Some background through.The two primary warehouse architectures are proposed by Kimball and Inmon. Inmon used to recommend a sin...
Shashikumar
- Jun 21st, 2007
EDW & DW are one & the same. If scope of data warehouse is enterprise wide it is called Enterprise data warehouse.If the scope of data warehouse is limited to department it is called Data mart.Transformation which uses cache are,Lookup,Joiner,Aggregator,Rank
-
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
-
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
sakthi.jaganathan
- Aug 25th, 2008
The only way to join two flat file is joiner transformation,if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat file...
Mamta11
- Jul 26th, 2008
Use joiner transformation. If the structure of both the flat files is same you can also use union transformation
-
What is a transforamation?
It is a repostitory object that generates,modifies or passes data.
sprajarajan
- Aug 8th, 2008
A TransFormation Is a Repository Object.That Generates,Modifies or Passes Data.The Designer Provides a Set of Transformations That perform Specific Functions.For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.
bibhu
- Nov 10th, 2006
Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.
-
What are the steps follow in performance tuning ?
J.David Sukeerthi Kumar
- Nov 26th, 2007
Bottle neck means drawbacks or problems
-
What is a junk dimension
vivek1708
- Jul 30th, 2008
Junk dimensions are particularly useful in Snowflake schema and one of the reasons why snowfalke is preferred over the star schema.There are dimensions that are frequently updated. So from the base se...
ravi kumar guturi
- Mar 10th, 2006
A junk dimension is a used for constrain queary purpose based on text and flag values.Some times a few dimensions discarded in a major dimensions , That time we kept in to one place the all discarded dimensions that is called junk dimensions.
-
How do you test mapping and what is associate port?
sreedhark26
- Mar 26th, 2007
HiU can test mapping in mapping Designer by using debugger. In Debugger u can test first instance and next instance. associated port is output port.sreedhar
-
Failed Workflow
When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps to run the workflow.
vivek1708
- Jul 29th, 2008
As u wish to run the workflow frm the second session, just go to workflow manager,right click on the session that u wish the begin the sequence from and click on 'start workflow from task'
garunchowdary
- Feb 29th, 2008
If you configure a session in a sequential batch to stop on failure,you can run recovery starting with the failed session.The Infomatica server completes the session and then runs the rest of the batc...
-
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...
-
Use of Aggregator Transformation
In source qualifier transformation we can writer customer query. That means we can do aggregator calculations also. So what is the need of Aggregator Transformation?
Mamta11
- Jul 26th, 2008
What if you want to aggregate the data down the pipeline (after manipulating the source data). This is where you require aggregate transformation.
ravi_se2000
- Jan 16th, 2008
Sourcequalifier transformation filters rows when it reads the souce data from the PowerCenter Server if you give any filter condition, but Aggregator transformation is used for multiple filter conditi...
-
Checksum and Pipeline
What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?
Mamta11
- Jul 26th, 2008
Pipeline in information means a series of transformation starting from one set of sources to a target set of targets.
subashreddy77
- Apr 27th, 2008
Hipipeline is the flow of data from source to target using some transformations(if required)tell me if u got what is check some and where it is usedif i was wrong please tell me where i am wrongbye nad take care
-
When do you use Normal Loading and the Bulk Loading, Tell the difference?
vivekvish
- Jul 24th, 2008
You would use Normal Loading when the target table is indexed and you would use bulk loading when the target table is not indexed. Running Bulk Load in an indexed table will cause the session to fail.
chandrarekha
- Sep 28th, 2007
Normal Load: It loads the records one by one, Server writes log file for each record, So it takes more time to load the data.Bulk load : It loads the number of records at a time, it does not write any log files or tracing levels, so it takes less time.
Informatica Interview Questions
Ans