-
-
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
-
Mapping Logic
Give any one logic you have implemented in mappinig except SCD Type2 (real time logic)?
-
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.
-
Accessing AEP
How can we access the AEP (Advanced External Procedure) in Informatica8.1?
-
Informatica Project Locks
How to open project locks in Informatica?
-
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...
-
Create a New Domain in Informatica
How to create a new domain in Informatica PowerCenter Repository Manager? What is the Gateway Host and Gateway Port to create a new domain?
-
Power Exchange
What is Power Exchange?
latha.c
- Apr 19th, 2010
Power Exchange deals with the mainframes. CDC (Change Data Capture) source concept also there means?insteed of using delta process logic with different transformations?in the Informatica?PowerCenter, we can create CDC sources in power exchange and import that into power center.ThanksLatha
hundwanipankaj
- Apr 5th, 2010
Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs
-
How does normalizer works
Can some one tell how normalizer works with an example? Please
hundwanipankaj
- Apr 21st, 2010
Normalizer is used with COBOL database, In COBOL database data is stored in denormalized form, It is used to create multiple rows from single row of data or in other words it converts denormalized data into normalized form.
RAJ
- Aug 3rd, 2006
Normalization is used to transform non tabular data structure into tabular format mainly required for COBOL data files.
-
Informatica Transformation Scenarios
Outline different transformation scenarios.
-
HOw do u select duplicate rows using informatica?
Anindya1281
- May 11th, 2010
This can be done using SQL query in case of relational sourcesvariables in an expression in case of reltn and flat file srcsIn case of Infa 8.x we have an inbuilt function called MD5 which can be used...
sravan
- Nov 4th, 2006
We can aso use sorter transfermation.seect distinct one check box.
-
How to extract 10 records out of 100 records in a flat file
Anindya1281
- May 11th, 2010
There are multiple ways to do it src-->seq gen --> trans --> tgtUse a seq gen to get transaction id1) Filter TransUse filter to filter in transaction id<=102) RouterRoute transaction id<...
afzal
- Nov 3rd, 2006
hi,For falt file sourecsource--sq--sequence generator tran.on new fileld id--filter tran. id<=10--traget
-
Partitioning, Bitmap Indexing (when to use), how will the bitmap indexing will effect the performance
Anindya1281
- May 16th, 2010
Bitmap indexes are widely used in data warehousing environments. The environments typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions. For such appl...
Shanmugam
- Jul 6th, 2006
Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-norm...
Informatica Interview Questions
Ans