2 tables are present on 2 oracle databases, How to join those 2 tables? Which transformation should be used?

RAMESHKUMARREDDY

• Feb 18th, 2007

Hi these two tables are coming from different oracle data bases we can use joiner transformatin to join them if there if is no relation we can join based on datatypes

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 8th, 2007

Import these two tables from source one by one. Then drag to source screen.Then by the common field of both the tables just drag from one table to another table.

Answer Question  Select Best Answer

Chetan

• Mar 2nd, 2018

What if the we have
1,100,Banglore
2,100,chennai
3,100,Mysore
1,101,bangalore
2,101,Kol

Your query will retun 2,3 and we will get
2,100,chennai
3,100,Mysore
2,101,Kol as output

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Sorry for my previous post. I missed a bit of question.

select * from where version in (select max(version) from group by id, loc_no)

Answer Question  Select Best Answer

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

Target commit intervals and Source - based commit intervals.

J.David Sukeerthi Kumar

• Nov 26th, 2007

Bottle neck means drawbacks or problems

Answer Question  Select Best Answer

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

There are 3 ways are available to generate sequence numbers with out using Sequence Generator Transformation, 1) Using Exp Tfn variable concept v_cnt(v)=o_cnt+1 o_cnt(o)=v_cnt 2)using mapping variabl...

Venkateswara Rao Rajanala

• Oct 14th, 2014

You can use output port and say CUME(1).. this will automatically generate the sequence or use Variable port
Var= var+1 and Output port = Var...This will generate the sequence for you

Answer Question  Select Best Answer

Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?

sahan

 Profile Answers by sahan Questions by sahan

• Jul 16th, 2009

You can do it by performing session recovery.When you enable session recovery option, the integration service?makes the entries to opb_session_recovery table and notes the row id of the last row comm...

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Apr 14th, 2008

How would you know whether the server commited or not? You can run the session again by setting the recovery opton enable and recover the session..which starts processing from the point where it was s...

Answer Question  Select Best Answer

What transformation do you use to convert source column into target rows? Explain

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Normalizer is basically used to convert rows to columns. I don't think alone normalizer is sufficient to convert columns into rows. In certain scenario you use this sequence of t/f to convert columns ...

Ishaan_Kulshrestha

 Profile Answers by Ishaan_Kulshrestha Questions by Ishaan_Kulshrestha

• Apr 14th, 2010

Hi Sahan,Please let me know how aggregator is used here. I think Aggregator is required when we denormalise data and here our requirement is to Normailse the data.Please correct me if I am wrong. Thanks

Answer Question  Select Best Answer

Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.

Read Best Answer

Editorial / Best Answer

Answered by: Praveen vasudev

• Sep 12th, 2005

---

Aggregator transform is m uch like the Group by clause in traditional SQL.

this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.

From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.

veepee

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.

shr_4

 Profile Answers by shr_4 Questions by shr_4

• Oct 27th, 2010

To perform Group by calculations  we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference  between both is that Aggregator Transform...

Improve Answer

sppk

• Jul 18th, 2011

The update transformation/strategy uses the concept of keys, in order to update the target table. As flat file do not have any Keys defined on it, it is not possible to update the target,. which is a flat file.

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Apr 9th, 2008

You can modify the flat file using shell scripting in unix ( awk, grep, sed ).Hope this helps.

Answer Question  Select Best Answer

chinap24

 Profile Answers by chinap24 Questions by chinap24

• Apr 11th, 2008

Using an update strategy transformation...We can insert the new rows using INSERT option in T1 and insert duplicate rows using UPDATE option in T2

sri.kal

 Profile Answers by sri.kal Questions by sri.kal

• Apr 10th, 2008

We  can achieve this by using router t/r.

Answer Question  Select Best Answer

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.i have windows server 2003 OSPlease, any one have a solution to this problem

junupt

 Profile Answers by junupt Questions by junupt

• Apr 29th, 2009

-- Makesure correct server name is entered-- Click on "Resolve Server" button 

krishna chaitanya

• May 11th, 2007

Problem with your userid and password.Missing repository installation files.

Answer Question  Select Best Answer

I have installed Informatica 7.1.1 and Oracle.But the Informatica server service starts momentarily and then stops.I have uninstalled and installed Informatica twice and removed from the registry as well, but the problem persists.Does any body have the solution for this

pulak

• Aug 3rd, 2016

Informatica error - server service starts momentarily and then stops to resolve this kind of issue 1. check whether your Repository user is locked 2. check whether your Repository user pass is ex...

krkreddys

 Profile Answers by krkreddys Questions by krkreddys

• Aug 8th, 2014

It is because of your Repository user is locked/(database not open). Go to oracle database Repository user try to login to repository, then unlock it. It works fine.

Answer Question  Select Best Answer

Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee Name from Employee table based on the Employee IDPerform Calculation.Update slowly changing dimension tables - We can use unconnected lookup transformation to determine whether the records already exist...

Read Best Answer

Editorial / Best Answer

Answered by: prodyot Sarkar

• Jul 31st, 2007

---

The following reasons for using lookups.....

1)We use Lookup transformations that query the largest amounts of data to improve overall performance. By doing that we can reduce the number of lookups on the same table.

2)If a mapping contains Lookup transformations, we will enable lookup caching if this option is not enabled .
We will use a persistent cache to improve performance of the lookup whenever possible.
We will explore the possibility of using concurrent caches to improve session performance.
We will use the Lookup SQL Override option to add a WHERE clause to the default SQL statement if it is not defined
We will add ORDER BY clause in lookup SQL statement if there is no order by defined.
We will use SQL override to suppress the default ORDER BY statement and enter an override ORDER BY with fewer columns. Indexing the Lookup Table
We can improve performance for the following types of lookups:
For cached lookups, we will index the lookup table using the columns in the lookup ORDER BY statement.
For Un-cached lookups, we will Index the lookup table using the columns in the lookup where condition.

3)In some cases we use lookup instead of Joiner as lookup is faster than joiner in some cases when lookup contains the master data only.

4)This lookup helps in terms of performance tuning of the mappings also.

Satya

• Aug 9th, 2014

Use lookup transformation in a mapping to
--get related values
--perform complex calculation
--Handle slowly changing dimension.

gazulas

 Profile Answers by gazulas Questions by gazulas

• Apr 22nd, 2009

Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions,? so in middle of the mapping there is a requirement to get the data from some? x t...

Improve Answer

venkat

• Apr 11th, 2014

We can not use folloeing transformations in a mapplet. Target: This will change the difference between mapping and mapplet. XML and COBOL sources. Normalizer: Im not sure if we can use it as a trans...

prafulla kumar nayak

• Mar 18th, 2014

Below objects we can use inside maplet

1.Non reusable sequence generator transformation.
2.pre or post stored procedure transformation.
3.Normalized transformation
4.xml source qualifier transformation
5.xml source
6.target

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 13th, 2010

For a banking domain if we are Maintaining customer infowarehouse the size of DB is 9GB1.4 dimensions-Customer,period or time,productand promotion2.7 fact tables3.approx min 45 mappings

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

I think the interviewer wants to the number of facts and dimensions in the warehouse, and not the size in GB's or TB of the actual Database.

Answer Question  Select Best Answer

ahammed

 Profile Answers by ahammed Questions by ahammed

• Aug 2nd, 2010

First load the data into dimension table. If all the dimension data loaded is succeded then only load all dimension tables data into fact table.

shekhar.aadi

 Profile Answers by shekhar.aadi Questions by shekhar.aadi

• Jul 22nd, 2010

We are using mapplets and joiner transformation is used for mapplet.

Answer Question  Select Best Answer

Asha Frank

• Dec 6th, 2017

Reusable and non-reusable

sivaKumar

• Feb 18th, 2017

There are totally two types of session,
1.Reusable session,
2.Non_reusable session,

1.Reusable_session: When you create session under task developer, this is reusable session.

2.Non_reusable_session: When you create session under workflow this is non_reusable session.

Thank you

Answer Question  Select Best Answer

What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.

Surbhit

• Apr 1st, 2014

Use an aggregator and do no group by any key

Ankit Kansal

• Feb 15th, 2014

Easy way of achieving the functionality is with Unix commands however if you want to achieve it using Informatica only then Then just before dumping your data to your target use aggregator count() f...

Answer Question  Select Best Answer

If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.

Rishak

 Profile Answers by Rishak Questions by Rishak

• May 21st, 2012

If you want to check the records,you can directly use MINUS query for eg

Code
 

Hope this will help Thanks Risha

skaur29

 Profile Answers by skaur29 Questions by skaur29

• Nov 17th, 2011

1) Check Session Logs
2) Use Preview Data option for Target in PowerCenter once session is completed
3) Sql queries if it is a Relational database

Answer Question  Select Best Answer

Why Union transformation is active while it returns same number of rows as in the sources?

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 18th, 2010

Union transformation is an active transformation and it does changes the number of records.Suppose source has following columns:Name, School, CollegeABC, SKM, IIT-DXYZ, DAV, IIMThere are total 10 rows...

harikr

 Profile Answers by harikr Questions by harikr

• Dec 1st, 2009

An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.Union Transformation does UNION ALL; hence...

Answer Question  Select Best Answer

Explain a mapping design to start aggregating the values before getting all the rows from the source.

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Agg t/f when using unsorted data, it do not perform agg calculation until it receives all the source rows from the pipeline, on the other hand when using sorted data for Agg t/f agg calculation starts...

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 4th, 2010

Here we taken this context as two ways aggregate value means for example if we take sales sum(sales)min(sales)max(sales)and the second context isfor the  better performance we use the sorter before aggregator incoming values of the source

Answer Question  Select Best Answer