-
ETL Tool Complete Process in Informatica
What is the complete process in Informatica power center client tool? Explain using ETL tool
vijaykumar2009
- Dec 9th, 2009
ETL complete process done as fallows: In INFORMATICA POWER CENTER DESIGNER Creation of source table Creation of target table Creation of mapping :plan of implement business logic &nbs...
DK_Reddy
- Apr 19th, 2009
ETL-Extraction (from Source)-Transformation-Loading (to Target)In this process There are 2 servers active at the same time 1) Informatica Server. 2) Repository ServerHere Informatica Server Connec...
-
How do you fine tune the mapping and what methods we follow for different types of transformations?
harikr
- Dec 17th, 2009
A Mapping can be fine tuned for performance at the following levels :1.Optimize the target. 2.Optimize the source3.Optimize the mapping4.Optimize the transformation5.Optimize the session6.O...
-
Union Transformation
Why Union Transformation is active while it passes all the rows through it.
etluser
- Dec 28th, 2009
By definition, a transformation is treated as active if the number of input rows do not match the number of output rows. Since Union transoformation accepts input rows from multiple pieplines, and com...
-
What will be the way to send only duplicate records to the Target?
sheeladere
- Dec 30th, 2009
If you want to directly get the records from some relational table then you can use the query in Source qualifier to group by on all the columns and get the count of records and pass the records which...
sanjeev
- Aug 6th, 2007
If you take a ex:EMP TABLE? having the duplicate recordsThe query isSELECT *FROM EMP WHERE EMPNO IN SELECT EMPNO FROM EMP GROUP BY EMPNO HAVING COUNT(*)>1;Sanjeeva Reddy
-
Individual Sequence Numbers
How to create individual sequence numbers for each department wise?
etluser
- Jan 3rd, 2010
Here are the steps1. Assume that there are four departments and that the source is a source file that contains dept id.2. Create four Sequence Generator transformations.3. Create an exp...
-
Importing data through fixed-width wizard
When importing data through fixed-width wizard, how will u distinguish between different columns if the file is of multiple lines terminated by a n character.
sheeladere
- Jan 4th, 2010
In the Fixed width file, the columns will be allotted with some specific length( fixed width), suppose your file contains 5 columns and total length of the file record is 100, then while defining...
Motilal
- Jun 30th, 2006
Ya.. Can anybody please give any suggestions?I think the source file needed to be cleaned manually
-
Retrieve only Distinct Record from 'flatfile' Source
How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?
sheeladere
- Jan 5th, 2010
We can use Aggregate transformation for this. Group by on all the columns in the Aggregator and get only first or last record from the group, it will give you distinct records.But sorter is the best option, I am not sure why you want to avoid it, is there any specific reason?
jsrprasad0402
- Sep 22nd, 2009
Create a Variable port for all the input port and keep them in a seequence that the variable ports will access first after the input port. Then, compare the same variable ports in the ouput port along...
-
Target Data Loading
How & Where will you can see data loading in targets dynamically?
sharmahariom
- Jan 18th, 2010
You can use Power Center Monitor. Once you will open property window in monitor you can see dynamic data loading there.
vens28
- Apr 28th, 2009
We can check the target recorded loaded dynamically? by validating the query on target records with time period.1) We need to run the target records related query for? first load with time period an...
-
SAP R/3 Data Extraction
How to extract data from SAP R/3 system to a DWH?
ntonsalli
- Feb 12th, 2010
Informatica PowerConnect for SAP R/3 will provide Informatica PowerCenter customers with high-speed data extraction from SAP R/3. Using PowerConnect for SAP R/3, users will be able to access all SAP R...
-
What is the difference between type 1& type 2 dimension
versionking
- Feb 19th, 2010
Type 1: Update with current data.Type 2: Stores history ie all past and current data.Type 3: Prev data and current data only.
vizaik
- Mar 21st, 2007
There are 3 scd typesscd type1: Only current detailsscd type2: History + current detailsscd type3: Initial + current detailsIn projects, we mainly use scd type1
-
How to load data based on even and odd record numbers
In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and winch transformations we are using?and explain logic?
srinivas jupally
- Feb 22nd, 2010
We can get using mod(Nextval,2) function in expression. After expression use Router transformation.You can connect nextval port from sequence generator transformation.Thanks,Srinivas.J
-
What is the difference between source definition database and source qualifier?
madhu.tella
- Mar 25th, 2010
Source definition in database is simply the table definition, but the source qulifier is one of the transformation in informaitca from which we can specify the data selection criteria to the database....
vemurisasidhar
- Sep 24th, 2007
A source definition database contain the datatypes that are used in the orginal database from which the source is extracted. where the source qualifier is used to convert the source definition datatypes to the informatica datatypes. which is easy to work with.
-
How can we call Stored Procedure in Work Flow Manager?
rajvinformatica
- Mar 28th, 2010
I have written as Stored Procedure to get all the Tables from a two Server Server1 and Server2 (parameterized Values) and load them in to two different tables internally through the S.PThis ...
sarita.harsh
- Mar 5th, 2009
Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connecti...
-
Work Flow manger error 'cannot connect to the server'
When i was running workflow manager i.e, when i right click the task icon and clicking start workflow from task, i am getting a message like 'cannot connect to the server'. Can any body guide me, how to get the output.Thanks
libinjose
- Apr 2nd, 2010
In that case you may query the fields from below Informatica repository tables and populate into your target tables. REP_WFLOW_RUN (WORKFLOW_NAME, RUN_ERR_MSG, RUN_STATUS_CODE) REP_TASK_INST_RUN(INSTA...
gargnakul
- Feb 14th, 2007
Hi ,Can anybody please help me in case i want to store values of workflow monitor in target table .Like suppose if i run any workflow and check the status in workflow monitor.Now my requirement is tha...
-
Source Qualifier in Informatica
What is the Technical reason for having Source Qualifier in Informatica? Can a mapping be implemented without it? (Please don't mention the functionality of SQ) but the main reason why a mapping can't do without it...
manojrana
- Apr 7th, 2010
The most important significance of source qualifier is that it converts the datatypes (coming from a source) into informatica compatible datatypes.Rest all properties like distinct, overide, filtering records can be achieved by other transformations of informatica as well.
chandra Bose
- Sep 4th, 2007
In informatica source qualifier acts as a staging area, and it?will create?its own?data types which are related to source data types
-
What is SQL override? In which transformation we use override?
itjmn
- Apr 12th, 2010
Chaning / altering the default querly generated by the following transformations is known a SQL Override.1. Source Qualifier Transformations2. Lookup3. Target
Vamsi Krishna.K
- Oct 1st, 2006
Hello,By default informatica server will generate sql query for every action, if that query is not able to perform the exact task, we can modify that query or we can genrate new once with new conditions and with new constraints.1. source qualifier2. lookup3. target
-
Could any one please tell me how informatica behaves in the following situation?(Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS status to a record.RESULT=IIF((A > (100 - B))OR(C > (100 - D))OR(E0) , 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))Where the following variables are decimalsA (Decimal(9,2)) = 2.0179896789716073791692725900792e-5B(Decimal(9,2)) = 99C(Decimal(9,2)) = 50D(Decimal(9,2))= 99E(Decimal(9,2))= 0F(Decimal(9,2))=2681.75Problem is that system is showing FAIL but expected to be PASS.How the systems behaves with exponent values?1) would informatica drops the exponent and takes 2 as 'A'2) takes exponent (A) as is (0.00%)
vamannam
- Apr 12th, 2010
I think you have to use below expressionIIF ( (A > (100 - B)),'FAIL', IIF( (C > (100 - D)),'FAIL', IIF((E<= F AND F>0), 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))))Regards,Vamsi
-
How do you join the table if there is no relation ship
question was asked from accenture and Wipro.
vamannam
- Apr 12th, 2010
The main aim of your question is that you have to load the both table’s data in to your target table with joining of the two tables even if you don’t have a common column to join both tabl...
sridhar.gonda
- Oct 27th, 2007
U hav to create a dummy common column in both tables thn u can join both tables.
-
Fact Table - Grain Facts
What are Grain Facts?
Anindya1281
- Apr 15th, 2010
In simple words grain can be considered as the lowest level in which you can store data in a table for example you want to store daily sale of a product and you have different stores so store_id ...
AVRKAM
- Jan 3rd, 2010
This is about granularity. that is, what level of data detail should be made avaialble in the dimension model. A reference to ATOMIC DATA has to be made here.Atomic data is the most expressive da...
-
What is the difference between Informatica server, Repository Server and Power center Server ?
Can any one explain clearly the difference between Informatica server, Repository Server, Power center Server ?
latha.c
- Apr 16th, 2010
Informatica is company name and Power Center is its product. Its advantage is build it once and deploy it anywhere. In Informatica Architecture we have 3 major components called 1. Client to...
akmohanty
- Feb 14th, 2007
Both the Informatica Server and Power Centre server are same meaning in Informatica.Its working to work proceedings for sessions and workflows in workflow Manager windows.The Repository server of Inf...
Informatica Interview Questions
Ans