Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

informatica complex question

Status
Not open for further replies.
senthil45

senthil45

Programmer
Sep 1, 2015
1
0
0
IN
My input is below:

emp id day in time out time
3433 5000 8 AM 01:00 PM
3433 5000 02 PM 06:00 PM
3433 5001 8 AM 05:00 PM
3454 5000 08 AM 05:00 PM
3454 5001 08 AM 05:00 PM
3454 5002 5 AM 08 AM
3454 5002 09 AM 4 PM
3454 5002 4:05 PM 08 PM

Note: 5000- Monday, 5001-tuesday,5003-wednesday so on till 5007- sunday

Output Needed:

empid inand out time
3433 M-8AM to 06 PM,T-8AM to 05 PM
3454 M-T 8AM to 5PM,W-5AM to 8 PM

How can i implement the above scenario in transformation?
 
Status
Not open for further replies.

Similar threads

sa0309
  • Locked
  • Question
Passing an Oracle SP error message to Informatica Email Task
Replies
0
Views
54
sa0309
sa0309
newbie1314
  • Locked
  • Question
New to informatica, need help with expression transformations
Replies
0
Views
39
newbie1314
newbie1314
donafran
  • Locked
  • Question
Columns Tab question
Replies
1
Views
45
johnherman
johnherman
donafran
  • Locked
  • Question
Data Stage LOG detail question
Replies
2
Views
43
donafran
donafran
naveends
  • Locked
  • Question
Netezza with Informatica 1
Replies
4
Views
55
rasETL
rasETL

Part and Inventory Search

Sponsor

Back
Top