Answer / syeda

Hi,

Its basically the interest you have to learn new
technologies. You can very well shift to B.I tools and its
very interesting when compared to 4gl. I was with 4gl for
arnd 2.5 yrs then shifted to Informatica for a few months
and then again back to 4gl which I didnt wanted to but as
the requirement and need was highly critical and essential
I had to come back to 4gl. Otherwise B.I tools will really
be a very good option to change to.

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

Define Incremental Aggregation?

2 Answers  

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

Define enterprise data warehousing?

0 Answers  

---

What is parameter file?

2 Answers  

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---