rakesh

• Jul 20th, 2016

No because if given in a tabular form then it would easily understandable and readable

anilkumarin1

 Profile Answers by anilkumarin1 Questions by anilkumarin1

• Dec 30th, 2008

A shortcut is a reference (link) to an object in a shared folder, these are commonly used for sources and targets that are to be shared between different environments / or projects. A shortcut is crea...

Answer Question  Select Best Answer

HiI am having 10000 records in flat file, in that there are 100 records are duplicate records..soo we want to eliminate those records..which is the best method we have to follow.RegardsMahesh Reddy

avneeshrathor

 Profile Answers by avneeshrathor Questions by avneeshrathor

• Nov 3rd, 2009

Using sorter (with distinct option checked) will not tell what all records were duplicate. There is even a better way of doing it without using aggregator and all. it just uses expression transformation.

balaji_r

 Profile Answers by balaji_r Questions by balaji_r

• Feb 24th, 2009

Use aggregate on primary keys

Answer Question  Select Best Answer

avneeshrathor

 Profile Answers by avneeshrathor Questions by avneeshrathor

• Nov 3rd, 2009

For some special cases like for example, You need to select the max salary
from emp table for a particular dept. then use
"select max(salary) from emp where deptno=in_dept_no
group by deptno".

Kindly let me know if this is possible without using SQL override in lookup.

ask_kaushik

 Profile Answers by ask_kaushik Questions by ask_kaushik

• Dec 6th, 2007

Lookup override can be used to get some specific records(using filters in where clause) from the lookup table. Adavantages are that the whole table need not be looked up..

Answer Question  Select Best Answer

ORAINFO

 Profile Answers by ORAINFO Questions by ORAINFO

• Nov 18th, 2008

The Integration Service updates target tables based on key values. However, you can override the default UPDATE statement for each target in a mapping. You might want to update the target based on non...

miteshcpatel

 Profile Answers by miteshcpatel Questions by miteshcpatel

• Sep 12th, 2008

When we don't have primary keys defined on database level. And still we need update on this target from Informatica. We neeed to define keys at informatica level and use update override in target property. This way we can update the table.

Answer Question  Select Best Answer

How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the columns. if the count=1 then it will be a valid record. what to do if the count >2.means file contains duplicate records.Why we need to use joiner after aggregator?

VISHNU VARDHAN

• Nov 17th, 2015

Use HAVING Condition in SELECT clause, You can write code like below to test, if it is greater than one then it is duplicate otherwise Unique.

Code
 

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 7th, 2012

Hi, Its similar to the SQL query, SELECT * FROM ,,.... FROM TABLE_NAME GROUP BY ,,..... HAVING COUNT(*)=1 Similarly in Informatica Aggregator transformation, select group by for all the columns and...

Answer Question  Select Best Answer

What are Grain Facts?

Anindya1281

 Profile Answers by Anindya1281 Questions by 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

 Profile Answers by AVRKAM Questions by 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...

Answer Question  Select Best Answer

What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.

Manjunath

• Apr 9th, 2015

both Dim Modeling and ER modeling can be 3NF, which is highly normalized, As raj mentioned ER is used for OLTP and DM for OLAP. in both the cases data is stored in a set of tables and related to each ...

Sharat

• Jan 5th, 2015

Raj, 1NF is highly denormalized and the higher forms are more normalized. You said Dimensional Modeling is for datawarehouses and uses 3NF. Contains denormalized data. 3NF is highly normalized and how can the datawarehouses can have denormalized data

Answer Question  Select Best Answer

How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by 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

 Profile Answers by Mamta11 Questions by Mamta11

• Jul 26th, 2008

Use joiner transformation. If the structure of both the flat files is same you can also use union transformation

Answer Question  Select Best Answer

What is the difference between SQL Override and Lookup Override

VENKATM

• Jan 2nd, 2016

You cannot use directly Union in Lookup Override. You can use in SQL Override. No join conditions in SQL Override. Join condition is compulsory in lookup.

dbseeker

 Profile Answers by dbseeker Questions by dbseeker

• Dec 20th, 2015

Can we have a different opinion on the 4th point? "Lookup override gives only one record even though there..." A lookup can return more than one record. We could handle this using the lookup property ...

Answer Question  Select Best Answer

Hi, I am new to Informatica just trying to do some mappings. I tried to do SCD type 1. after loading source tables I used expression transformation to do some formatting and then I used Router Transformation. But when I tried to post all fields from expression to router they are by default becoming only input variables . I am unable to link these variables to an Update Strategy. What to do now???...

babushiv

 Profile Answers by babushiv Questions by babushiv

• Jun 18th, 2009

All the Above answers are wright, just create port in group and name it as update if you want to update, by default a port is created, now just map into corresponding router trans from update transThanksBabu Shiv

sakthi.jaganathan

 Profile Answers by sakthi.jaganathan Questions by sakthi.jaganathan

• Aug 25th, 2008

In Router transformation first you want create a group, how can you create?a group means, in expression transformation?you will?set a?flag values, you just click the group tab in router transforma...

Answer Question  Select Best Answer

How to calculate max value of a column without using aggregrator transformation?

dihydrox

 Profile Answers by dihydrox Questions by dihydrox

• Dec 6th, 2008

If you just need to get the max value by the end of session (to increment a value or put at the bottom of a flat file ) you can do the following.  Let's say you need to find the max value f...

jryan999

 Profile Answers by jryan999 Questions by jryan999

• Sep 1st, 2008

You need to feed your ports through an Aggregator Tranformation.  eg.Input  = salary.  Not outputOutput = maximum_salary --> max(salary) - OutputConnect the maximum_salary fields to ...

Answer Question  Select Best Answer

How the data flows from dimensions to fact table?

wmilford

 Profile Answers by wmilford Questions by wmilford

• Feb 24th, 2009

Data in reality does not flow from dimensions to facts or visa versa. Dimensions contain textual descriptive information in a business unit of an Enterprise. This kind of data is usually contained in ...

sameer_solidcore

 Profile Answers by sameer_solidcore Questions by sameer_solidcore

• Feb 20th, 2009

In a Data Warehouse Consider there are two tables, D and F, where F is a fact table and D is a dimension table. A dimension table is the one which contains the Primary key and a Fact table is the...

Answer Question  Select Best Answer

Which is the faster way - Adding a record at the beginning of a file or adding a record at the end of a file? Explain

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Feb 11th, 2011

Best way is to have a flag in the data to denote it is last row. =Powercenter reads till end of data and it reads in blocks, so it doesn't =expose the state of the last record.

Surya_prakash

 Profile Answers by Surya_prakash Questions by Surya_prakash

• Feb 10th, 2011

Adding index in to source qualifier and drop the index in the target table.

Answer Question  Select Best Answer

rakesh

• May 18th, 2012

TO_CHAR(DATE,MM) or
TO_CHAR(DATE,MON) or
TO_CHAR(DATE,FMMONTH)

mouni

• Apr 30th, 2012

Ex :to_char(trunc(sysdate),mm)
to_char(date,mm)

Answer Question  Select Best Answer

I have a table having column col1, col2. If for a col1 there is some data in col2.

EX: Col1=0012 and Col2 = 12,13,14

then i need these three values 12, 13,14 separately not as a single string as it is in table. Or you can say in need to separate these three values after it is returned by query.There may be only one value or more than 3 as well.

EX: 12,13,14,15.........

Divya

• Aug 2nd, 2013

I think it can be done with normalizer...
it will end up like

0012 12
0012 13
0012 14

PREETHI

• Dec 7th, 2011

Can you do this in Sybase. For ex: To separate the door nos. alone from a address column.

PREETHI

Answer Question  Select Best Answer

HiIam learning informatica 8.1 ( which is what i could get my hands on)..I am connecting to oracle 10g.I created 2 connections to the DB using Connection --> Relational Connection Browser.The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name. then...

Gatla Dileep reddy

• Feb 16th, 2015

It is a DB issue, If the Session failed in middle just try to recover the workflow.

Vids

• Aug 13th, 2013

The error seems to be DB error . First of all , check at the database level if the source and the target table are created correctly. Then using INSERT stmt , try to insert a record in Oracle databa...

Answer Question  Select Best Answer

What is the difference between STOP and ABORT options in Workflow Monitor?

Satish

• Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Sudha Rani

• Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Answer Question  Select Best Answer

Employee name start with A pass to one target,Employee name start with S pass to 2nd target,Employee name start with J pass to 3rd target,other pass to other target.

Sandy

• Aug 31st, 2014

To make current answers generic and mapping applies even if you get more names starting with different characters: Use Sorter, Expression & Transaction control transformations - Using sorter transfor...

amrie

• Jul 30th, 2014

In the expression Create a variable port v_employee= IIF( substr(EMPLOYEENAME,1,1)=A,FLAG1 IIF( SUBSTR(EMPLOYEENAME,1,1)=S,FLAG2, IIF( SUBSTR(EMPLOYEENAME,1,1)=J,FLAG3,FLAG4 ))) create a output po...

Answer Question  Select Best Answer

How can I maintain unique surrogate key if 2 separate workflow in different repository run at the same time and insert/update the main table.
Please let me know how can I achieve the above scenario.

Venkateswara Rao

• Oct 14th, 2014

In this scenario the best approach is to define a sequence in Database (ex :oracle ).. Call in informatica when ever you want . even if it is across multiple repositories it will work.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Yes, we can. But we need to export/import the mapplet in different repositories. Working with Mapplets: After you create a mapplet, you can validate or edit the mapplet in the Mapplet Designer. You c...

Answer Question  Select Best Answer

How can we receive source as flat file in informatica, from where we get this flat file?

sri

• Jun 18th, 2017

We get flatfile from source to target, which is in file format like MS-Word, etc

Anil

• Jun 22nd, 2016

To explain it clearly we have to know the concept of using FTP. Consider a banking project, the product owner gives all data to production team and not to developer, the 3rd party team gives another d...

Answer Question  Select Best Answer